package com.ssms.dao;

import com.ssms.model.Clazz;
import org.apache.ibatis.annotations.Param;
import org.springframework.web.bind.annotation.PathVariable;

import java.util.List;

public interface ClazzMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Clazz record);

    int insertSelective(Clazz record);

    Clazz selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Clazz record);

    int updateByPrimaryKey(Clazz record);

    List<Clazz> selectAll(Integer subjectId);

    List<Clazz> selectByInstructor(Integer instructor);

    List<Clazz> selectPage(@Param("start") int start, @Param("size") int size, @Param("subjectId") Integer subjectId);

    int selectPageCount(@Param("subjectId") Integer subjectId);

    List<Clazz> selectAllBySubjectId(@Param("subjectId") Integer subjectId);

    List<Clazz> selectByClazzNo(String clazzNo);

    Clazz selectByClzNoAndSbjNo(@Param("clazzNo") String clazzNo,@Param("subjectNo") String subjectNo);

}